insert overwrite table jms_dim.dim_lmdm_sys_first_code
select
id
,name
,code
,attributes
,type
,center_id
,center_name
,center_code
,center_province_id
,destination_country_id
,destination_province_id
,destination_city_id
,destination_area_id
,destination_town_id
,origin_country_id
,origin_province_id
,origin_city_id
,origin_area_id
,origin_town_id
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,effect_time
,invalid_time
,version
,sort
,modified_time
,dest_center_id
,dest_center_code
,dest_center_name
from jms_ods.yl_lmdm_sys_first_code where dt = '{{ execution_date | cst_ds }}'
 distribute by 1 ;